Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	42896
Missing cells	52072
Missing cells (%)	7.1%
Duplicate rows	906
Duplicate rows (%)	2.1%
Total size in memory	12.9 MiB
Average record size in memory	315.7 B

Variable types

Numeric	11
Categorical	4
Text	2

Alerts

`type` has constant value "audio_features"	Constant
Dataset has 906 (2.1%) duplicate rows	Duplicates
`acousticness` is highly overall correlated with `energy` and 1 other fields	High correlation
`duration_ms` is highly overall correlated with `instrumentalness`	High correlation
`energy` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`instrumentalness` is highly overall correlated with `acousticness` and 1 other fields	High correlation
`loudness` is highly overall correlated with `energy`	High correlation
`time_signature` is highly imbalanced (84.3%)	Imbalance
`loudness` has 9170 (21.4%) missing values	Missing
`song_name` has 21085 (49.2%) missing values	Missing
`title` has 21817 (50.9%) missing values	Missing
`key` has 3520 (8.2%) zeros	Zeros
`instrumentalness` has 11473 (26.7%) zeros	Zeros

Reproduction

Analysis started	2025-03-19 16:14:43.582273
Analysis finished	2025-03-19 16:14:49.950826
Duration	6.37 seconds
Software version	ydata-profiling vv4.15.0
Download configuration	config.json

danceability
Real number (ℝ)

Distinct	921
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.63933611

Minimum	0.0651
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0.0651
5-th percentile	0.378
Q1	0.524
median	0.646
Q3	0.766
95-th percentile	0.878
Maximum	0.988
Range	0.9229
Interquartile range (IQR)	0.242

Descriptive statistics

Standard deviation	0.15658499
Coefficient of variation (CV)	0.24491811
Kurtosis	-0.48618557
Mean	0.63933611
Median Absolute Deviation (MAD)	0.121
Skewness	-0.265132
Sum	27424.962
Variance	0.024518859
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.804	193	0.4%
0.808	166	0.4%
0.8	154	0.4%
0.802	153	0.4%
0.805	150	0.3%
0.803	150	0.3%
0.809	141	0.3%
0.81	136	0.3%
0.807	134	0.3%
0.792	126	0.3%
Other values (911)	41393	96.5%

Value	Count	Frequency (%)
0.0651	2	< 0.1%
0.0753	1	< 0.1%
0.0891	2	< 0.1%
0.0979	1	< 0.1%
0.106	2	< 0.1%
0.111	1	< 0.1%
0.116	1	< 0.1%
0.119	1	< 0.1%
0.121	1	< 0.1%
0.123	1	< 0.1%

Value	Count	Frequency (%)
0.988	3	< 0.1%
0.985	4	< 0.1%
0.984	1	< 0.1%
0.983	2	< 0.1%
0.982	1	< 0.1%
0.981	1	< 0.1%
0.98	2	< 0.1%
0.979	2	< 0.1%
0.978	3	< 0.1%
0.977	2	< 0.1%

energy
Real number (ℝ)

High correlation

Distinct	955
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.76256045

Minimum	0.000243
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0.000243
5-th percentile	0.425
Q1	0.632
median	0.803
Q3	0.923
95-th percentile	0.982
Maximum	1
Range	0.999757
Interquartile range (IQR)	0.291

Descriptive statistics

Standard deviation	0.18369117
Coefficient of variation (CV)	0.24088736
Kurtosis	-0.20130099
Mean	0.76256045
Median Absolute Deviation (MAD)	0.135
Skewness	-0.73716286
Sum	32710.793
Variance	0.033742448
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.977	191	0.4%
0.953	172	0.4%
0.988	171	0.4%
0.97	170	0.4%
0.956	169	0.4%
0.924	165	0.4%
0.963	162	0.4%
0.98	159	0.4%
0.951	159	0.4%
0.942	158	0.4%
Other values (945)	41220	96.1%

Value	Count	Frequency (%)
0.000243	2	< 0.1%
0.000602	1	< 0.1%
0.0127	1	< 0.1%
0.0148	1	< 0.1%
0.0223	1	< 0.1%
0.0279	2	< 0.1%
0.0297	1	< 0.1%
0.0321	1	< 0.1%
0.0393	1	< 0.1%
0.0453	1	< 0.1%

Value	Count	Frequency (%)
1	5	< 0.1%
0.999	22	0.1%
0.999	3	< 0.1%
0.998	87	0.2%
0.997	94	0.2%
0.996	100	0.2%
0.995	123	0.3%
0.994	144	0.3%
0.994	4	< 0.1%
0.993	133	0.3%

key
Real number (ℝ)

Zeros

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3685658

Minimum	0
Maximum	11
Zeros	3520
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.6649926
Coefficient of variation (CV)	0.68267629
Kurtosis	-1.365958
Mean	5.3685658
Median Absolute Deviation (MAD)	4
Skewness	-0.00095694629
Sum	230290
Variance	13.432171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	7641	17.8%
7	4332	10.1%
11	4197	9.8%
6	3767	8.8%
0	3520	8.2%
8	3405	7.9%
10	3294	7.7%
9	3293	7.7%
2	3093	7.2%
5	3047	7.1%
Other values (2)	3307	7.7%

Value	Count	Frequency (%)
0	3520	8.2%
1	7641	17.8%
2	3093	7.2%
3	910	2.1%
4	2397	5.6%
5	3047	7.1%
6	3767	8.8%
7	4332	10.1%
8	3405	7.9%
9	3293	7.7%

Value	Count	Frequency (%)
11	4197	9.8%
10	3294	7.7%
9	3293	7.7%
8	3405	7.9%
7	4332	10.1%
6	3767	8.8%
5	3047	7.1%
4	2397	5.6%
3	910	2.1%
2	3093	7.2%

loudness
Real number (ℝ)

High correlation Missing

Distinct	11257
Distinct (%)	33.4%
Missing	9170
Missing (%)	21.4%
Infinite	0
Infinite (%)	0.0%
Mean	-6.4638994

Minimum	-32.929
Maximum	3.148
Zeros	1
Zeros (%)	< 0.1%
Negative	33562
Negative (%)	78.2%
Memory size	335.3 KiB

Quantile statistics

Minimum	-32.929
5-th percentile	-11.626
Q1	-8.165
median	-6.2285
Q3	-4.52
95-th percentile	-2.00625
Maximum	3.148
Range	36.077
Interquartile range (IQR)	3.645

Descriptive statistics

Standard deviation	2.9381711
Coefficient of variation (CV)	-0.45455087
Kurtosis	1.4448485
Mean	-6.4638994
Median Absolute Deviation (MAD)	1.817
Skewness	-0.62893063
Sum	-218001.47
Variance	8.6328493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.142	19	< 0.1%
-6.186	17	< 0.1%
-5.892	16	< 0.1%
-5.943	16	< 0.1%
-5.572	15	< 0.1%
-5.334	15	< 0.1%
-5.531	15	< 0.1%
-4.162	15	< 0.1%
-7.641	15	< 0.1%
-5.545	14	< 0.1%
Other values (11247)	33569	78.3%
(Missing)	9170	21.4%

Value	Count	Frequency (%)
-32.929	1	< 0.1%
-26.172	1	< 0.1%
-26.113	1	< 0.1%
-24.694	1	< 0.1%
-24.563	1	< 0.1%
-24.203	1	< 0.1%
-23.577	1	< 0.1%
-23.39	1	< 0.1%
-23.385	1	< 0.1%
-23.035	1	< 0.1%

Value	Count	Frequency (%)
3.148	1	< 0.1%
2.499	1	< 0.1%
2.363	1	< 0.1%
2.185	1	< 0.1%
1.949	1	< 0.1%
1.877	1	< 0.1%
1.851	1	< 0.1%
1.85	1	< 0.1%
1.833	1	< 0.1%
1.792	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

1	23571
0	19325

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42896
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring characters

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	23571	54.9%
0	19325	45.1%

speechiness
Real number (ℝ)

Distinct	1474
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.13644625

Minimum	0.0227
Maximum	0.946
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0.0227
5-th percentile	0.0348
Q1	0.0491
median	0.0754
Q3	0.193
95-th percentile	0.398
Maximum	0.946
Range	0.9233
Interquartile range (IQR)	0.1439

Descriptive statistics

Standard deviation	0.12597627
Coefficient of variation (CV)	0.92326664
Kurtosis	2.889166
Mean	0.13644625
Median Absolute Deviation (MAD)	0.0347
Skewness	1.6715108
Sum	5852.9984
Variance	0.015870021
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.102	123	0.3%
0.106	116	0.3%
0.105	115	0.3%
0.109	113	0.3%
0.111	112	0.3%
0.11	110	0.3%
0.113	106	0.2%
0.107	104	0.2%
0.114	100	0.2%
0.124	96	0.2%
Other values (1464)	41801	97.4%

Value	Count	Frequency (%)
0.0227	2	< 0.1%
0.0232	2	< 0.1%
0.0235	1	< 0.1%
0.0238	1	< 0.1%
0.0239	1	< 0.1%
0.0241	1	< 0.1%
0.0242	3	< 0.1%
0.0243	1	< 0.1%
0.0244	2	< 0.1%
0.0245	1	< 0.1%

Value	Count	Frequency (%)
0.946	1	< 0.1%
0.944	1	< 0.1%
0.914	1	< 0.1%
0.908	3	< 0.1%
0.906	1	< 0.1%
0.905	1	< 0.1%
0.902	2	< 0.1%
0.898	1	< 0.1%
0.89	1	< 0.1%
0.888	1	< 0.1%

acousticness
Real number (ℝ)

High correlation

Distinct	4707
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.096260315

Minimum	1.07 × 10^-6
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	1.07 × 10^-6
5-th percentile	8.9475 × 10^-5
Q1	0.00173
median	0.0164
Q3	0.107
95-th percentile	0.497
Maximum	0.988
Range	0.98799893
Interquartile range (IQR)	0.10527

Descriptive statistics

Standard deviation	0.17084273
Coefficient of variation (CV)	1.7747992
Kurtosis	6.5271008
Mean	0.096260315
Median Absolute Deviation (MAD)	0.016194
Skewness	2.5299953
Sum	4129.1825
Variance	0.029187238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.128	75	0.2%
0.114	74	0.2%
0.106	69	0.2%
0.125	69	0.2%
0.0138	68	0.2%
0.105	61	0.1%
0.0105	60	0.1%
0.102	57	0.1%
0.111	57	0.1%
0.133	56	0.1%
Other values (4697)	42250	98.5%

Value	Count	Frequency (%)
1.07 × 10^-6	1	< 0.1%
1.14 × 10^-6	1	< 0.1%
1.21 × 10^-6	1	< 0.1%
1.46 × 10^-6	1	< 0.1%
1.81 × 10^-6	1	< 0.1%
1.83 × 10^-6	1	< 0.1%
1.93 × 10^-6	1	< 0.1%
2.14 × 10^-6	1	< 0.1%
2.43 × 10^-6	1	< 0.1%
2.46 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.987	1	< 0.1%
0.986	2	< 0.1%
0.985	1	< 0.1%
0.984	1	< 0.1%
0.983	1	< 0.1%
0.982	2	< 0.1%
0.98	1	< 0.1%
0.978	3	< 0.1%
0.976	3	< 0.1%

instrumentalness
Real number (ℝ)

High correlation Zeros

Distinct	4867
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.28322936

Minimum	0
Maximum	0.989
Zeros	11473
Zeros (%)	26.7%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.00596
Q3	0.722
95-th percentile	0.909
Maximum	0.989
Range	0.989
Interquartile range (IQR)	0.722

Descriptive statistics

Standard deviation	0.37081022
Coefficient of variation (CV)	1.3092224
Kurtosis	-1.2495296
Mean	0.28322936
Median Absolute Deviation (MAD)	0.00596
Skewness	0.75166777
Sum	12149.407
Variance	0.13750022
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	11473	26.7%
0.871	93	0.2%
0.897	90	0.2%
0.901	85	0.2%
0.895	85	0.2%
0.858	79	0.2%
0.874	79	0.2%
0.865	78	0.2%
0.892	77	0.2%
0.883	77	0.2%
Other values (4857)	30680	71.5%

Value	Count	Frequency (%)
0	11473	26.7%
1 × 10^-6	5	< 0.1%
1.01 × 10^-6	13	< 0.1%
1.02 × 10^-6	13	< 0.1%
1.03 × 10^-6	13	< 0.1%
1.04 × 10^-6	16	< 0.1%
1.05 × 10^-6	7	< 0.1%
1.06 × 10^-6	13	< 0.1%
1.07 × 10^-6	9	< 0.1%
1.08 × 10^-6	7	< 0.1%

Value	Count	Frequency (%)
0.989	3	< 0.1%
0.988	1	< 0.1%
0.987	1	< 0.1%
0.986	1	< 0.1%
0.985	1	< 0.1%
0.983	1	< 0.1%
0.982	1	< 0.1%
0.981	6	< 0.1%
0.979	2	< 0.1%
0.978	4	< 0.1%

liveness
Real number (ℝ)

Distinct	1737
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.21408004

Minimum	0.0107
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0.0107
5-th percentile	0.0615
Q1	0.0996
median	0.135
Q3	0.294
95-th percentile	0.61825
Maximum	0.988
Range	0.9773
Interquartile range (IQR)	0.1944

Descriptive statistics

Standard deviation	0.17546346
Coefficient of variation (CV)	0.81961618
Kurtosis	3.0811814
Mean	0.21408004
Median Absolute Deviation (MAD)	0.0546
Skewness	1.7803261
Sum	9183.1773
Variance	0.030787427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.111	689	1.6%
0.109	487	1.1%
0.107	455	1.1%
0.11	443	1.0%
0.106	432	1.0%
0.105	368	0.9%
0.102	364	0.8%
0.114	349	0.8%
0.113	348	0.8%
0.115	316	0.7%
Other values (1727)	38645	90.1%

Value	Count	Frequency (%)
0.0107	1	< 0.1%
0.0121	3	< 0.1%
0.0135	1	< 0.1%
0.0141	3	< 0.1%
0.0147	1	< 0.1%
0.0149	1	< 0.1%
0.0153	3	< 0.1%
0.0159	1	< 0.1%
0.0182	1	< 0.1%
0.0188	1	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.981	2	< 0.1%
0.979	1	< 0.1%
0.978	3	< 0.1%
0.976	1	< 0.1%
0.975	5	< 0.1%
0.973	2	< 0.1%
0.97	1	< 0.1%
0.969	1	< 0.1%
0.968	1	< 0.1%

valence
Real number (ℝ)

Distinct	1716
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3571699

Minimum	0.0187
Maximum	0.988
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	0.0187
5-th percentile	0.0436
Q1	0.161
median	0.322
Q3	0.522
95-th percentile	0.797
Maximum	0.988
Range	0.9693
Interquartile range (IQR)	0.361

Descriptive statistics

Standard deviation	0.23325546
Coefficient of variation (CV)	0.65306582
Kurtosis	-0.60890607
Mean	0.3571699
Median Absolute Deviation (MAD)	0.175
Skewness	0.54957366
Sum	15321.16
Variance	0.054408108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.142	99	0.2%
0.158	97	0.2%
0.144	93	0.2%
0.186	92	0.2%
0.141	91	0.2%
0.175	90	0.2%
0.15	88	0.2%
0.178	88	0.2%
0.152	87	0.2%
0.159	87	0.2%
Other values (1706)	41984	97.9%

Value	Count	Frequency (%)
0.0187	2	< 0.1%
0.0196	3	< 0.1%
0.0199	1	< 0.1%
0.0206	3	< 0.1%
0.0218	3	< 0.1%
0.0228	1	< 0.1%
0.0235	1	< 0.1%
0.0236	1	< 0.1%
0.0237	1	< 0.1%
0.0239	2	< 0.1%

Value	Count	Frequency (%)
0.988	1	< 0.1%
0.98	3	< 0.1%
0.979	1	< 0.1%
0.976	2	< 0.1%
0.975	4	< 0.1%
0.974	2	< 0.1%
0.973	1	< 0.1%
0.972	3	< 0.1%
0.971	4	< 0.1%
0.97	5	< 0.1%

tempo
Real number (ℝ)

Distinct	15569
Distinct (%)	36.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	147.49209

Minimum	57.967
Maximum	220.29
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	57.967
5-th percentile	115.82175
Q1	129.91875
median	144.9705
Q3	161.5975
95-th percentile	192.8865
Maximum	220.29
Range	162.323
Interquartile range (IQR)	31.67875

Descriptive statistics

Standard deviation	23.861654
Coefficient of variation (CV)	0.1617826
Kurtosis	0.10894812
Mean	147.49209
Median Absolute Deviation (MAD)	15.455
Skewness	0.47899078
Sum	6326820.5
Variance	569.37851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
150.02	59	0.1%
125	57	0.1%
149.998	51	0.1%
125.002	50	0.1%
128	49	0.1%
150	48	0.1%
149.992	47	0.1%
125.007	46	0.1%
123.999	46	0.1%
128.005	44	0.1%
Other values (15559)	42399	98.8%

Value	Count	Frequency (%)
57.967	1	< 0.1%
61.309	1	< 0.1%
64.331	1	< 0.1%
64.934	1	< 0.1%
64.95	1	< 0.1%
66.424	1	< 0.1%
67.003	1	< 0.1%
69.986	1	< 0.1%
70.022	1	< 0.1%
70.231	1	< 0.1%

Value	Count	Frequency (%)
220.29	1	< 0.1%
220.232	1	< 0.1%
220.216	1	< 0.1%
220.154	1	< 0.1%
220.152	1	< 0.1%
220.148	2	< 0.1%
220.138	1	< 0.1%
220.13	1	< 0.1%
220.112	1	< 0.1%
220.102	1	< 0.1%

type
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

audio_features	42896

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	600544
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	audio_features
2nd row	audio_features
3rd row	audio_features
4th row	audio_features
5th row	audio_features

Common Values

Value	Count	Frequency (%)
audio_features	42896	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
audio_features	42896	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	600544	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	600544	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	600544	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	85792	14.3%
u	85792	14.3%
e	85792	14.3%
d	42896	7.1%
i	42896	7.1%
o	42896	7.1%
_	42896	7.1%
f	42896	7.1%
t	42896	7.1%
r	42896	7.1%

duration_ms
Real number (ℝ)

High correlation

Distinct	26261
Distinct (%)	61.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	250913.57

Minimum	25600
Maximum	913052
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.3 KiB

Quantile statistics

Minimum	25600
5-th percentile	121186
Q1	179971.25
median	224663
Q3	301288.5
95-th percentile	457973.25
Maximum	913052
Range	887452
Interquartile range (IQR)	121317.25

Descriptive statistics

Standard deviation	102979.76
Coefficient of variation (CV)	0.41041926
Kurtosis	0.49528913
Mean	250913.57
Median Absolute Deviation (MAD)	54250
Skewness	0.95262368
Sum	1.0763189 × 10¹⁰
Variance	1.0604831 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
192000	105	0.2%
240000	87	0.2%
224000	68	0.2%
211200	57	0.1%
230400	57	0.1%
172800	52	0.1%
217600	49	0.1%
236800	43	0.1%
268800	43	0.1%
168000	39	0.1%
Other values (26251)	42296	98.6%

Value	Count	Frequency (%)
25600	1	< 0.1%
35862	1	< 0.1%
38333	1	< 0.1%
41290	1	< 0.1%
42133	1	< 0.1%
43807	1	< 0.1%
48107	1	< 0.1%
48423	1	< 0.1%
48667	1	< 0.1%
49227	1	< 0.1%

Value	Count	Frequency (%)
913052	1	< 0.1%
894386	1	< 0.1%
855502	1	< 0.1%
847302	1	< 0.1%
821168	1	< 0.1%
774294	1	< 0.1%
757972	1	< 0.1%
752000	1	< 0.1%
728413	1	< 0.1%
723573	2	< 0.1%

time_signature
Categorical

Imbalance

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.0 MiB

4	40999
3	1227
5	519
1	151

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42896
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	3
5th row	4

Common Values

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring characters

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	42896	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	40999	95.6%
3	1227	2.9%
5	519	1.2%
1	151	0.4%

genre
Categorical

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.3 MiB

Underground Rap	5948
Dark Trap	4634
Hiphop	3080
trance	3038
techhouse	3019
Other values (10)	23177

Length

Max length	15
Median length	10
Mean length	7.6035761
Min length	3

Characters and Unicode

Total characters	326163
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dark Trap
2nd row	Dark Trap
3rd row	Dark Trap
4th row	Dark Trap
5th row	Dark Trap

Common Values

Value	Count	Frequency (%)
Underground Rap	5948	13.9%
Dark Trap	4634	10.8%
Hiphop	3080	7.2%
trance	3038	7.1%
techhouse	3019	7.0%
dnb	3017	7.0%
trap	3014	7.0%
techno	3007	7.0%
psytrance	3003	7.0%
hardstyle	2981	6.9%
Other values (5)	8155	19.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
trap	9632	17.4%
rap	7818	14.1%
underground	5948	10.7%
dark	4634	8.4%
hiphop	3080	5.6%
trance	3038	5.5%
techhouse	3019	5.4%
dnb	3017	5.4%
techno	3007	5.4%
psytrance	3003	5.4%
Other values (5)	9266	16.7%

Most occurring characters

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	326163	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	326163	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	326163	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	35184	10.8%
a	33090	10.1%
p	27081	8.3%
n	26089	8.0%
e	25999	8.0%
t	20046	6.1%
d	17894	5.5%
o	17227	5.3%
h	15106	4.6%
	12566	3.9%
Other values (19)	95881	29.4%

song_name
Text

Missing

Distinct	15439
Distinct (%)	70.8%
Missing	21085
Missing (%)	49.2%
Memory size	2.0 MiB

Length

Max length	138
Median length	94
Mean length	15.5058
Min length	1

Characters and Unicode

Total characters	338197
Distinct characters	190
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11537 ?
Unique (%)	52.9%

Sample

1st row	Mercury: Retrograde
2nd row	Pathology
3rd row	Symbiote
4th row	ProductOfDrugs (Prod. The Virus and Antidote)
5th row	Venom

Value	Count	Frequency (%)
feat	2494	4.0%
the	1698	2.7%
	1655	2.6%
you	760	1.2%
me	759	1.2%
i	725	1.2%
a	589	0.9%
my	514	0.8%
it	500	0.8%
of	467	0.7%
Other values (10934)	52297	83.7%

Most occurring characters

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.1%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (180)	152232	45.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	338197	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.1%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (180)	152232	45.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	338197	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.1%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (180)	152232	45.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	338197	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	40647	12.0%
e	29068	8.6%
a	19569	5.8%
o	17404	5.1%
t	16500	4.9%
i	15879	4.7%
n	13890	4.1%
r	12634	3.7%
l	10336	3.1%
s	10038	3.0%
Other values (180)	152232	45.0%

title
Text

Missing

Distinct	132
Distinct (%)	0.6%
Missing	21817
Missing (%)	50.9%
Memory size	2.1 MiB

Length

Max length	49
Median length	37
Mean length	22.348546
Min length	4

Characters and Unicode

Total characters	471085
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Dirtybird Players
2nd row	Tech House Movement
3rd row	tech house
4th row	Tech House Bangerz
5th row	tech house

Value	Count	Frequency (%)
	5310	7.0%
2020	4148	5.5%
trance	3894	5.2%
hardstyle	3072	4.1%
techno	3065	4.1%
bass	3014	4.0%
drum	2963	3.9%
psytrance	2637	3.5%
euphoric	2066	2.7%
house	2065	2.7%
Other values (142)	43109	57.2%

Most occurring characters

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	471085	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	471085	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	471085	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	54284	11.5%
e	33420	7.1%
s	25916	5.5%
a	25025	5.3%
r	22909	4.9%
o	18765	4.0%
n	17752	3.8%
c	17585	3.7%
i	17407	3.7%
t	15676	3.3%
Other values (61)	222346	47.2%

	acousticness	danceability	duration_ms	energy	genre	instrumentalness	key	liveness	loudness	mode	speechiness	tempo	time_signature	valence
acousticness	1.000	0.212	-0.399	-0.534	0.166	-0.508	-0.021	-0.077	-0.179	0.026	0.285	0.091	0.063	0.191
danceability	0.212	1.000	-0.109	-0.372	0.243	-0.141	-0.009	-0.232	-0.265	0.086	0.255	-0.239	0.074	0.358
duration_ms	-0.399	-0.109	1.000	0.310	0.323	0.524	0.065	-0.056	-0.050	0.080	-0.295	-0.126	0.045	-0.190
energy	-0.534	-0.372	0.310	1.000	0.227	0.385	0.037	0.212	0.568	0.036	-0.099	0.021	0.060	-0.050
genre	0.166	0.243	0.323	0.227	1.000	0.293	0.078	0.118	0.227	0.169	0.187	0.420	0.083	0.183
instrumentalness	-0.508	-0.141	0.524	0.385	0.293	1.000	0.067	-0.053	-0.141	0.033	-0.429	-0.228	0.032	-0.356
key	-0.021	-0.009	0.065	0.037	0.078	0.067	1.000	-0.011	-0.006	0.414	-0.015	-0.010	0.015	0.027
liveness	-0.077	-0.232	-0.056	0.212	0.118	-0.053	-0.011	1.000	0.183	0.000	0.073	0.087	0.011	-0.030
loudness	-0.179	-0.265	-0.050	0.568	0.227	-0.141	-0.006	0.183	1.000	0.026	0.075	0.244	0.046	0.083
mode	0.026	0.086	0.080	0.036	0.169	0.033	0.414	0.000	0.026	1.000	0.051	0.050	0.006	0.026
speechiness	0.285	0.255	-0.295	-0.099	0.187	-0.429	-0.015	0.073	0.075	0.051	1.000	0.186	0.051	0.272
tempo	0.091	-0.239	-0.126	0.021	0.420	-0.228	-0.010	0.087	0.244	0.050	0.186	1.000	0.065	0.055
time_signature	0.063	0.074	0.045	0.060	0.083	0.032	0.015	0.011	0.046	0.006	0.051	0.065	1.000	0.034
valence	0.191	0.358	-0.190	-0.050	0.183	-0.356	0.027	-0.030	0.083	0.026	0.272	0.055	0.034	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title
0	0.831	0.814	2	-7.364	1	0.4200	0.0598	0.013400	0.0556	0.3890	156.985	audio_features	124539	4	Dark Trap	Mercury: Retrograde	None
1	0.719	0.493	8	-7.230	1	0.0794	0.4010	0.000000	0.1180	0.1240	115.080	audio_features	224427	4	Dark Trap	Pathology	None
2	0.850	0.893	5	NaN	1	0.0623	0.0138	0.000004	0.3720	0.0391	218.050	audio_features	98821	4	Dark Trap	Symbiote	None
3	0.476	0.781	0	-4.710	1	0.1030	0.0237	0.000000	0.1140	0.1750	186.948	audio_features	123661	3	Dark Trap	ProductOfDrugs (Prod. The Virus and Antidote)	None
4	0.798	0.624	2	-7.668	1	0.2930	0.2170	0.000000	0.1660	0.5910	147.988	audio_features	123298	4	Dark Trap	Venom	None
5	0.721	0.568	0	-11.295	1	0.4140	0.0452	0.212000	0.1280	0.1090	144.915	audio_features	112511	4	Dark Trap	Gatteka	None
6	0.718	0.668	8	-4.162	1	0.1370	0.0254	0.007800	0.1240	0.0380	130.826	audio_features	77584	4	Dark Trap	kamikaze (+ pulse)	None
7	0.694	0.711	8	NaN	1	0.2210	0.0397	0.000000	0.1120	0.2830	138.049	audio_features	127524	3	Dark Trap	T.R.U. (Totally Rotten Underground)	None
8	0.774	0.751	1	-2.445	1	0.1980	0.0614	0.000000	0.0728	0.1890	219.960	audio_features	140326	4	Dark Trap	I Put My Dick in Your Mental	None
9	0.893	0.907	11	-10.406	1	0.3670	0.1520	0.031100	0.5580	0.3020	199.942	audio_features	121979	4	Dark Trap	Andromeda	None

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title
42886	0.875	0.753	8	-6.899	0	0.0901	0.040500	0.000099	0.1680	0.7350	112.002	audio_features	210187	4	Trap Metal	Smoke Break	None
42887	0.589	0.783	6	-11.170	1	0.0413	0.000421	0.916000	0.0839	0.0345	123.995	audio_features	410323	4	techno	None	Dark Techno Rave
42888	0.623	0.845	8	-9.082	1	0.0508	0.016000	0.864000	0.0862	0.3690	134.978	audio_features	546707	4	trance	None	Top Trance Songs EVER
42889	0.674	0.990	5	NaN	1	0.2840	0.312000	0.000016	0.6270	0.5090	173.948	audio_features	182069	4	dnb	None	UKF Drum & Bass - All Uploads
42890	0.653	0.944	2	NaN	1	0.0917	0.001630	0.473000	0.3520	0.0754	139.970	audio_features	221000	4	trance	None	TRANNCE 2020 Best Trance Music Official
42891	0.802	0.630	9	-9.348	0	0.4320	0.204000	0.000002	0.0649	0.8770	144.008	audio_features	66743	4	Underground Rap	Bang Bros!	None
42892	0.565	0.996	11	NaN	0	0.0682	0.000050	0.816000	0.9220	0.0658	145.000	audio_features	590875	4	psytrance	None	PSYTRANCE BANGERS best new 2020
42893	0.514	0.955	0	-5.182	0	0.0402	0.000053	0.889000	0.3380	0.1100	138.030	audio_features	221007	4	trance	None	Top Trance Songs EVER
42894	0.749	0.639	1	-9.841	1	0.1940	0.080900	0.609000	0.3620	0.6490	153.003	audio_features	215202	4	Underground Rap	Southern Hostility	None
42895	0.645	0.980	0	-6.898	1	0.0445	0.000029	0.843000	0.3180	0.2600	143.018	audio_features	443077	4	psytrance	None	Psytrance: From Full on to Forrest Trance

Most frequently occurring

	danceability	energy	key	loudness	mode	speechiness	acousticness	instrumentalness	liveness	valence	tempo	type	duration_ms	time_signature	genre	song_name	title	# duplicates
422	0.631	0.623	8	-6.969	1	0.2650	0.463000	0.000002	0.1510	0.7650	160.460	audio_features	227893	4	Hiphop	Everything I Am	NaN	4
60	0.389	0.768	1	-4.765	1	0.2560	0.038000	0.000000	0.1190	0.3340	90.146	audio_features	183567	4	Rap	WRONG (feat. Lil Mosey)	NaN	3
98	0.431	0.961	2	-6.598	0	0.0603	0.000246	0.207000	0.3680	0.1630	138.001	audio_features	235187	4	trance	NaN	TRANNCE 2020 Best Trance Music Official	3
146	0.473	0.735	11	-6.131	0	0.0498	0.010600	0.000000	0.2660	0.6500	154.546	audio_features	179453	4	Emo	You're So Last Summer	NaN	3
150	0.476	0.407	4	-9.239	0	0.0368	0.247000	0.000000	0.1440	0.2260	178.258	audio_features	242467	4	RnB	Officially Missing You	NaN	3
182	0.495	0.891	1	-5.599	0	0.0504	0.001870	0.112000	0.3220	0.2240	149.982	audio_features	142400	4	hardstyle	NaN	Euphoric Hardstyle & Melodic Hardstyle	3
219	0.513	0.855	8	-3.664	1	0.0375	0.029300	0.933000	0.3160	0.0367	173.996	audio_features	364149	4	dnb	NaN	Liquid Drum & Bass	3
285	0.548	0.554	9	-6.408	1	0.0587	0.283000	0.000000	0.0708	0.3820	159.836	audio_features	207507	4	RnB	Stickwitu	NaN	3
301	0.554	0.978	4	NaN	1	0.1310	0.111000	0.000000	0.0731	0.5940	135.095	audio_features	162600	4	Emo	Faint	NaN	3
419	0.629	0.696	1	-5.572	0	0.3480	0.019500	0.000000	0.0554	0.6230	186.068	audio_features	207627	4	Hiphop	Gold Digger	NaN	3

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring